/*
 *  Copyright (c) 1998, Regents of the University of California
 *  All rights reserved.
 *  Redistribution and use in source and binary forms, with or without
 *  modification, are permitted provided that the following conditions are met:
 *
 *      * Redistributions of source code must retain the above copyright
 *        notice, this list of conditions and the following disclaimer.
 *      * Redistributions in binary form must reproduce the above copyright
 *        notice, this list of conditions and the following disclaimer in the
 *        documentation and/or other materials provided with the distribution.
 *      * Neither the name of the University of California, Berkeley nor the
 *        names of its contributors may be used to endorse or promote products
 *        derived from this software without specific prior written permission.
 *
 *  THIS SOFTWARE IS PROVIDED BY THE REGENTS AND CONTRIBUTORS ``AS IS'' AND ANY
 *  EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
 *  WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
 *  DISCLAIMED. IN NO EVENT SHALL THE REGENTS AND CONTRIBUTORS BE LIABLE FOR ANY
 *  DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES
 *  (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
 *  LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
 *  ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
 *  (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
 *  SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
 */

package org.demis.dwarf.core.mapping;

import org.demis.dwarf.core.db.Column;
import org.demis.dwarf.core.db.Table;
import org.demis.dwarf.core.object.ClassDescriptor;
import org.demis.dwarf.core.object.PropertyDescriptor;
import org.demis.dwarf.core.object.util.OneToOne;


/**
 * @version 1.0
 * @author <a href="mailto:demis27@demis27.net">Stéphane kermabon</a>
 */
public final class Mapping {

    private static Mapping instance = new Mapping();

    private OneToOne<Table, ClassDescriptor> tableToClass = new OneToOne<Table, ClassDescriptor>();

    private OneToOne<Column, PropertyDescriptor> columnToProperty = new OneToOne<Column, PropertyDescriptor>();

    private Mapping() {

    }

    public static Mapping getInstance() {
        return instance;
    }

    public void addMapping(Table table, ClassDescriptor classDescriptor) {
        tableToClass.add(table, classDescriptor);
    }

    public Table getTable(ClassDescriptor classDescriptor) {
        return tableToClass.getLeft(classDescriptor);
    }

    public ClassDescriptor getClassDescriptor(Table table) {
        return tableToClass.getRight(table);
    }

    public void addMapping(Column column, PropertyDescriptor propertyDescriptor) {
        columnToProperty.add(column, propertyDescriptor);
    }

    public Column getColumn(PropertyDescriptor propertyDescriptor) {
        return columnToProperty.getLeft(propertyDescriptor);
    }

    public PropertyDescriptor getPropertyDescriptor(Column column) {
        return columnToProperty.getRight(column);
    }

    public String getDefaultJavaType(Class aclass) {
        if (aclass == Boolean.class) {
            return "BIT";
        }
        else if (aclass == Character.class) {
            return "CHAR";
        }
        else if (aclass == Byte.class) {
            return "TINYINT";
        }
        else if (aclass == Short.class) {
            return "SMALLINT";
        }
        else if (aclass == Integer.class) {
            return "INTEGER";
        }
        else if (aclass == Long.class) {
            return "BIGINT";
        }
        else if (aclass == Float.class) {
            return "FLOAT";
        }
        else if (aclass == Double.class) {
            return "DOUBLE";
        }
        else if (aclass == java.util.Date.class) {
            return "TIMESTAMP";
        }
        else if (aclass == java.sql.Date.class) {
            return "DATE";
        }
        else if (aclass == java.sql.Time.class) {
            return "TIME";
        }
        else if (aclass == java.sql.Timestamp.class) {
            return "TIMESTAMP";
        }
        else if (aclass.equals(String.class)) {
            return "VARCHAR";
        }

        return "null";
    }
}
